Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 8 Forum

Notes/Domino 8 Forum
Previous Next
Subject: Intermittent Connection (DB2 Agent on System i)
Feedback Type: Problem
Product Area: Domino Server
Technical Area: Application development
Platform: iSeries
Release: 8.0.2
Reproducible: Intermittent

I am experiencing a strange connection issue with an agent that connects to a DB2 database on System i. This agent has worked fine for over a year and just started having "ad hoc" problems connecting. If I use a data connection, I can test fine and access tables with no problem. There does not appear to be an issue with the DB2 database. It does not appear to be network issues. There is no maintenance that would take the database offline during this period, etc. The agent runs fine 90% of the time... might run 5 days straight then just not connect. Here is what appears in the log. It seemed to start right after the 8.0.2 upgrade!?! Any thoughts re: troubleshooting this one? Guess I'll try and add some additional print statements to see if it is really connecting or not. FYI... ODBCConnection is used in the case (really CLI on System i). The error seems clear but am wondering at this stage. Thanks team... anyone else experienced agent connection problems after 8.0.2 upgrade?

note: the dbcollect.nsf is where the agent runs and collects data then distributes to the appropriate sales databases (starts with salesdb1).

09/30/2008 17:00:49 AMgr: Agent ('Update Docs from DB2)' in 'dbcollect.nsf') message box: Could not connect to T16BV3DD

09/30/2008 17:00:49 AMgr: Agent ('Update Docs from DB2)' in 'dbcollect.nsf') message box: database salesdb1

09/30/2008 17:00:49 AMgr: Agent ('Update Docs from DB2)' in 'dbcollect.nsf') message box: LS:DO- The requested operation requires that you first be connected to a data source.


Feedback number WEBB7K9FY4 created by ~Sanjay Umtumisonikle on 10/09/2008


Intermittent Connection (DB2 Agent ... (~Sanjay Umtumis... 9.Oct.08)
. . Re: Intermittent Connection (DB2 Ag... (~Patti Nonniste... 10.Oct.08)
. . . . Re: Intermittent Connection (DB2 Ag... (~Sanjay Umtumis... 11.Oct.08)
. . . . . . Re: Intermittent Connection (DB2 Ag... (~Holly Lopfooko... 14.Oct.08)
. . . . . . . . LS:DO (ODBCCOnnection) to LSX (DB2)... (~Sanjay Umtumis... 23.Oct.08)
. . . . . . . . . . Error occurred in SQL call level in... (~Sanjay Umtumis... 23.Oct.08)
. . . . . . . . . . . . Server restart & LS:DO problem (~Sanjay Umtumis... 23.Oct.08)
. . . . . . . . . . . . . . Re: Server restart & LS:DO problem (~Holly Lopfooko... 31.Oct.08)
. . LS:DO 8.0.1 to 8.0.2 (~Carol Lopachek... 10.Nov.08)
. . . . Failed Again (~Carol Lopachek... 18.Nov.08)
. . 8.0.2 ODBC Intermittent Connection ... (~Carol Lopachek... 18.Dec.08)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS